██    ██ ██    ██  ██████  ██  ██████  ██    ██ ███████ ██████  ██    ██ 
     ██  ██  ██    ██ ██       ██ ██    ██ ██    ██ ██      ██   ██  ██  ██  
      ████   ██    ██ ██   ███ ██ ██    ██ ██    ██ █████   ██████    ████   
       ██    ██    ██ ██    ██ ██ ██ ▄▄ ██ ██    ██ ██      ██   ██    ██    
       ██     ██████   ██████  ██  ██████   ██████  ███████ ██   ██    ██    
                                      ▀▀                                     
    
Timeline - Execution started 21/03/2023 20:54 UTC
By Guilherme Ruiz

Table of Contents¶

  • 1  Data preparation
    • 1.1  Load data
    • 1.2  Format data
    • 1.3  Merge data
  • 4  Data visualization
    • 4.1  First releases
      • 4.1.1  By region
    • 4.1  Last releases
      • 4.1.1  By region
    • 4.2  All Releases
      • 4.2.1  By card type
      • 4.2.2  By primary type
      • 4.2.3  By secondary type
      • 4.2.4  By attribute
      • 4.2.5  By monster type
      • 4.2.6  By Level/Rank
      • 4.2.7  By ATK
      • 4.2.8  By DEF
      • 4.2.9  By pendulum scale
      • 4.2.10  By link
  • 5  Debug
    • 5.1 Merge failed
  • 6  Epilogue
    • 6.1  HTML export

Data preparation¶

Load data¶

Cards file loaded
Speed duel cards file loaded
Sets file loaded

Format data¶

Merge data¶

Data visualization¶

Name Password Card type Property Archseries Effect type TCG status OCG status Page name Card page URL Artwork Errata Attribute Primary type Secondary type Monster type DEF Pendulum Scale Link Link Arrows ATK Level/Rank TCG Speed Duel status Character Set Card number Rarity Print Quantity Region Set page URL Release Series Set type Cover card Modification date
0 "A" Cell Breeding Device 34541863 Spell Card Continuous Spell Card NaN (Trigger Effect,) Unlimited Unlimited "A" Cell Breeding Device https://yugipedia.com/wiki/%22A%22_Cell_Breedi... NaN (Name,) <NA> <NA> NaN <NA> <NA> <NA> <NA> NaN <NA> <NA> <NA> <NA> Force of the Breaker FOTB-IT043 (Common,) <NA> <NA> IT https://yugipedia.com/wiki/Set_Card_Lists:Forc... 2007-05-16 Core Booster Booster pack (Volcanic Doomfire,) 2021-11-06 13:57:15
1 "A" Cell Breeding Device 34541863 Spell Card Continuous Spell Card NaN (Trigger Effect,) Unlimited Unlimited "A" Cell Breeding Device https://yugipedia.com/wiki/%22A%22_Cell_Breedi... NaN (Name,) <NA> <NA> NaN <NA> <NA> <NA> <NA> NaN <NA> <NA> <NA> <NA> Force of the Breaker FOTB-DE043 (Common,) <NA> <NA> DE https://yugipedia.com/wiki/Set_Card_Lists:Forc... 2007-05-16 Core Booster Booster pack (Volcanic Doomfire,) 2021-11-06 13:57:15
2 "A" Cell Breeding Device 34541863 Spell Card Continuous Spell Card NaN (Trigger Effect,) Unlimited Unlimited "A" Cell Breeding Device https://yugipedia.com/wiki/%22A%22_Cell_Breedi... NaN (Name,) <NA> <NA> NaN <NA> <NA> <NA> <NA> NaN <NA> <NA> <NA> <NA> Force of the Breaker FOTB-FR043 (Common,) <NA> <NA> FR https://yugipedia.com/wiki/Set_Card_Lists:Forc... 2007-05-05 Core Booster Booster pack (Volcanic Doomfire,) 2021-11-06 13:57:15
3 "A" Cell Breeding Device 34541863 Spell Card Continuous Spell Card NaN (Trigger Effect,) Unlimited Unlimited "A" Cell Breeding Device https://yugipedia.com/wiki/%22A%22_Cell_Breedi... NaN (Name,) <NA> <NA> NaN <NA> <NA> <NA> <NA> NaN <NA> <NA> <NA> <NA> Force of the Breaker FOTB-EN043 (Common,) <NA> <NA> EN https://yugipedia.com/wiki/Set_Card_Lists:Forc... 2007-05-16 Core Booster Booster pack (Volcanic Doomfire,) 2021-11-06 13:57:15
4 "A" Cell Breeding Device 34541863 Spell Card Continuous Spell Card NaN (Trigger Effect,) Unlimited Unlimited "A" Cell Breeding Device https://yugipedia.com/wiki/%22A%22_Cell_Breedi... NaN (Name,) <NA> <NA> NaN <NA> <NA> <NA> <NA> NaN <NA> <NA> <NA> <NA> Force of the Breaker FOTB-SP043 (Common,) <NA> <NA> SP https://yugipedia.com/wiki/Set_Card_Lists:Forc... 2007-05-05 Core Booster Booster pack (Volcanic Doomfire,) 2021-11-06 13:57:15
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
320868 Volcanic Cannon <NA> Skill Card <NA> (Volcanic,) NaN Illegal <NA> Volcanic Cannon https://yugipedia.com/wiki/Volcanic_Cannon NaN NaN <NA> <NA> NaN <NA> <NA> <NA> <NA> NaN <NA> <NA> Legal Axel Brodie Speed Duel GX: Duel Academy Box SGX1-DES16 (Common,) <NA> <NA> DE https://yugipedia.com/wiki/Set_Card_Lists:Spee... 2022-03-17 <NA> Collector's Set (Destiny HERO - Plasma, Elemental HERO Flame W... 2022-09-01 17:16:50
320869 Volcanic Cannon <NA> Skill Card <NA> (Volcanic,) NaN Illegal <NA> Volcanic Cannon https://yugipedia.com/wiki/Volcanic_Cannon NaN NaN <NA> <NA> NaN <NA> <NA> <NA> <NA> NaN <NA> <NA> Legal Axel Brodie Speed Duel GX: Duel Academy Box SGX1-FRS16 (Common,) <NA> <NA> FR https://yugipedia.com/wiki/Set_Card_Lists:Spee... 2022-03-17 <NA> Collector's Set (Destiny HERO - Plasma, Elemental HERO Flame W... 2022-09-01 17:16:50
320870 Volcanic Cannon <NA> Skill Card <NA> (Volcanic,) NaN Illegal <NA> Volcanic Cannon https://yugipedia.com/wiki/Volcanic_Cannon NaN NaN <NA> <NA> NaN <NA> <NA> <NA> <NA> NaN <NA> <NA> Legal Axel Brodie Speed Duel GX: Duel Academy Box SGX1-PTS16 (Common,) <NA> <NA> PT https://yugipedia.com/wiki/Set_Card_Lists:Spee... 2022-03-17 <NA> Collector's Set (Destiny HERO - Plasma, Elemental HERO Flame W... 2022-09-01 17:16:50
320871 Volcanic Cannon <NA> Skill Card <NA> (Volcanic,) NaN Illegal <NA> Volcanic Cannon https://yugipedia.com/wiki/Volcanic_Cannon NaN NaN <NA> <NA> NaN <NA> <NA> <NA> <NA> NaN <NA> <NA> Legal Axel Brodie Speed Duel GX: Duel Academy Box SGX1-ENS16 (Common,) <NA> <NA> EN https://yugipedia.com/wiki/Set_Card_Lists:Spee... 2022-03-17 <NA> Collector's Set (Destiny HERO - Plasma, Elemental HERO Flame W... 2023-01-06 09:43:52
320872 Volcanic Cannon <NA> Skill Card <NA> (Volcanic,) NaN Illegal <NA> Volcanic Cannon https://yugipedia.com/wiki/Volcanic_Cannon NaN NaN <NA> <NA> NaN <NA> <NA> <NA> <NA> NaN <NA> <NA> Legal Axel Brodie Speed Duel GX: Duel Academy Box SGX1-SPS16 (Common,) <NA> <NA> SP https://yugipedia.com/wiki/Set_Card_Lists:Spee... 2022-03-17 <NA> Collector's Set (Destiny HERO - Plasma, Elemental HERO Flame W... 2022-09-01 17:16:50

320873 rows × 36 columns

First releases¶

Obs: Only the first release of an individual card name

First release
Name
"A" Cell Breeding Device 2007-02-15
"A" Cell Incubator 2007-07-21
"A" Cell Recombination Device 2016-07-09
"A" Cell Scatter Burst 2006-11-16
"Infernoble Arms - Durendal" 2020-04-18
... ...
Zubaba Knight 2011-03-19
Zubababancho Gagagacoat 2019-11-09
Zuijin of the Ice Barrier 2020-11-21
Zure, Knight of Dark World 2005-08-11
Zushin the Sleeping Giant 2016-05-14

12414 rows × 1 columns

By region¶

First release
Region Name
AE 3-Hump Lacooda 2004-10-14
4-Starred Ladybug of Doom 2003-04-24
7 2004-10-14
7 Colored Fish 2002-10-24
7 Completed 2003-04-24
... ... ...
TC ZW - Phoenix Bow 2015-06-06
ZW - Tornado Bringer 2015-12-05
ZW - Ultimate Shield 2015-12-05
Zerozerock 2015-12-05
Zure, Knight of Dark World 2015-03-01

100324 rows × 1 columns

Last releases¶

Obs: Only the last release of an individual card name

Last release
Name
"A" Cell Breeding Device 2014-03-26
"A" Cell Incubator 2012-05-12
"A" Cell Recombination Device 2016-11-04
"A" Cell Scatter Burst 2014-03-26
"Infernoble Arms - Durendal" 2023-01-19
... ...
Zubaba Knight 2023-02-04
Zubababancho Gagagacoat 2023-02-04
Zuijin of the Ice Barrier 2021-12-18
Zure, Knight of Dark World 2022-12-01
Zushin the Sleeping Giant 2020-09-10

12414 rows × 1 columns

By region¶

Last release
Region Name
AE 3-Hump Lacooda 2004-10-14
4-Starred Ladybug of Doom 2003-04-24
7 2004-10-14
7 Colored Fish 2002-10-24
7 Completed 2003-04-24
... ... ...
TC ZW - Phoenix Bow 2015-06-06
ZW - Tornado Bringer 2015-12-05
ZW - Ultimate Shield 2015-12-05
Zerozerock 2015-12-05
Zure, Knight of Dark World 2015-03-01

100324 rows × 1 columns

All Releases¶

Obs: All releases includes reprints

By card type¶

Release 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Card type
Counter 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2 1 2 2 2 0 7 18 3
Monster Card 624 542 332 1277 2608 3240 2481 1935 2012 2045 2049 2344 2912 3712 3561 4045 3295 3322 3255 2887 3293 3380 3419 3945 799
Skill Card 0 1 1 2 3 8 13 10 20 9 5 5 10 21 21 21 15 16 15 14 60 52 14 52 2
Spell Card 117 172 112 511 984 1368 1040 794 823 732 734 627 848 1056 922 1170 1024 1047 996 1021 1174 1254 1205 1352 313
Trap Card 36 82 80 230 511 949 796 618 678 611 618 582 713 822 754 963 777 847 749 627 679 739 614 725 141

By primary type¶

Release 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Primary type
Effect Monster 84 146 177 506 1114 1978 1972 1489 1644 1669 1742 1880 2277 2834 2571 2999 2296 2353 2277 1781 2101 2211 2048 2546 459
Fusion Monster 49 38 31 81 172 151 126 158 193 115 36 70 164 117 60 128 196 238 249 163 167 221 168 331 84
Link Monster 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 177 437 495 262 332 241 49
Monster Token 0 0 0 0 0 0 1 4 6 5 9 5 7 6 17 14 14 24 17 21 15 31 33 46 2
Normal Monster 489 348 122 671 1294 1072 356 263 151 158 80 117 135 198 226 163 288 220 140 166 140 214 188 221 35
Ritual Monster 10 14 2 20 28 43 27 21 20 13 9 14 13 34 17 21 70 44 34 72 61 64 46 77 23
Synchro Monster 0 0 0 0 0 0 0 0 0 88 173 260 217 180 112 267 194 174 141 142 161 165 224 252 55
Xyz Monster 0 0 0 0 0 0 0 0 0 0 0 0 100 348 558 454 245 270 220 107 155 218 387 250 94

By secondary type¶

Release 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Secondary type
Flip monster 19 34 25 100 182 272 148 102 56 84 55 66 86 119 63 106 64 37 91 39 60 85 43 42 2
Gemini monster 0 0 0 0 0 0 0 0 70 23 37 1 7 33 27 16 15 43 10 2 21 6 4 3 2
Spirit monster 0 0 10 0 35 24 33 14 8 9 16 5 22 16 17 6 1 13 39 13 0 0 5 9 4
Toon monster 0 4 1 20 24 45 10 13 1 8 0 1 12 19 5 3 24 21 6 0 5 46 2 4 0
Tuner monster 0 0 0 0 0 0 0 0 0 104 198 337 301 190 113 267 213 183 193 215 189 238 275 316 52
Union monster 0 0 0 10 14 25 61 26 21 11 5 23 9 19 3 13 1 34 7 18 10 27 5 10 0

By attribute¶

Release 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Attribute
? 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 0 0 4 0
DARK 175 158 91 398 766 924 671 438 470 584 561 647 776 890 903 1050 962 1194 1030 981 1154 1094 918 1285 236
DIVINE 0 3 0 0 3 2 1 0 0 4 1 9 5 7 6 18 15 19 12 9 12 20 14 3 5
EARTH 232 190 111 395 875 928 697 548 496 505 534 650 693 870 735 1055 698 631 720 465 549 660 510 823 173
FIRE 24 25 22 73 158 238 199 168 186 146 165 147 242 320 418 274 291 237 174 204 332 268 241 297 66
LIGHT 61 49 40 164 306 485 475 399 431 467 383 487 594 883 833 1018 723 776 766 786 707 654 922 717 202
WATER 82 68 29 131 258 336 227 162 242 153 185 141 256 485 319 289 290 251 259 131 225 370 405 434 67
WIND 50 49 39 116 242 327 210 216 183 181 212 260 341 253 336 331 304 203 289 301 305 309 406 378 50

By monster type¶

Release 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Monster type
Aqua 50 40 19 84 154 185 85 58 62 48 47 38 88 158 77 87 82 62 50 41 26 72 128 112 23
Beast 47 36 15 77 179 183 176 103 98 82 102 144 166 172 167 225 133 134 106 90 85 112 146 190 28
Beast-Warrior 20 18 15 37 79 83 67 44 51 34 52 49 58 88 225 140 80 112 127 57 100 89 75 62 9
Creator God 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0
Cyberse 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 318 385 163 191 148 24
Dinosaur 15 12 4 21 37 50 39 66 43 32 27 29 65 63 82 56 12 19 82 34 87 24 31 48 28
Divine-Beast 0 3 0 0 3 2 1 0 0 4 1 9 4 7 6 18 15 19 12 9 12 20 14 3 5
Dragon 36 35 29 98 184 220 148 87 109 150 188 224 270 359 358 321 344 465 331 348 462 403 439 399 112
Fairy 30 19 16 56 125 195 136 131 177 133 76 110 218 158 146 262 193 177 261 214 180 178 260 233 51
Fiend 74 68 52 157 338 431 281 180 228 182 148 244 292 264 283 330 443 316 319 220 250 426 225 419 80
Fish 16 12 5 24 54 61 30 17 25 31 33 13 44 74 91 68 22 16 30 8 16 26 27 60 8
Insect 36 30 12 62 121 165 81 81 59 67 93 77 77 118 65 84 37 72 94 48 101 30 66 128 32
Machine 31 41 21 87 161 217 269 248 275 265 226 354 284 376 430 575 398 442 405 306 323 500 436 489 80
Plant 21 12 7 29 61 58 40 24 33 67 72 83 70 65 75 180 60 55 89 42 67 114 91 115 21
Psychic 0 0 0 0 0 0 0 0 0 43 43 34 66 50 49 62 100 90 77 76 45 56 104 98 21
Pyro 11 10 7 31 67 99 76 59 67 47 25 45 68 98 69 58 40 14 14 22 12 26 17 37 7
Reptile 10 7 3 13 37 58 41 42 86 38 77 76 60 100 51 38 32 27 8 17 39 25 88 50 5
Rock 22 22 13 39 88 104 117 95 56 67 56 50 67 162 121 156 92 115 57 24 37 172 59 67 17
Sea Serpent 5 2 1 7 14 15 27 15 17 15 44 23 25 122 49 32 41 17 21 16 31 36 35 42 2
Spellcaster 61 50 36 165 298 378 277 174 131 188 223 191 184 348 286 323 360 393 363 264 425 350 312 332 79
Thunder 10 12 7 25 50 58 38 34 30 46 20 78 50 76 42 47 40 22 31 57 37 20 29 51 12
Warrior 71 78 52 174 373 446 367 361 354 355 318 302 535 672 545 603 480 464 320 377 311 315 355 508 113
Winged Beast 23 19 13 47 85 115 47 70 63 73 114 136 175 108 181 213 160 166 128 94 85 88 144 153 19
Wyrm 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 58 74 44 75 22 56 50 63 54 10
Zombie 35 16 5 44 100 117 137 42 44 73 56 32 40 70 152 99 45 70 90 173 112 80 81 139 13

By Level/Rank¶

By ATK¶

By DEF¶

By pendulum scale¶

By link¶

Debug¶

Merge failed¶

Name Password Card type Property Archseries Effect type TCG status OCG status Page name Page URL Artwork Modification date Errata Attribute Primary type Secondary type Monster type DEF Pendulum Scale Link Link Arrows ATK Level/Rank index
2330 Damage = Reptile 44584775 Trap Card Continuous Trap Card NaN (Trigger Effect,) Unlimited Unlimited Damage = Reptile https://yugipedia.com/wiki/Damage_%3D_Reptile NaN 2021-05-26 12:51:20 (Any,) NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN damage = reptile
2933 Dogmatikatrix 35569555 Spell Card Continuous Spell Card (Dogmatika,) (Condition, Effect, Ignition-like Effect) NaN Unlimited Dogmatikatrix https://yugipedia.com/wiki/Dogmatikatrix NaN 2023-01-11 16:47:00 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN dogmatikatrix
3886 Fissioning Mother Spider 34034150 Monster Card NaN (Spider,) (Condition, Ignition Effect, Unclassified effect) NaN Unlimited Fissioning Mother Spider https://yugipedia.com/wiki/Fissioning_Mother_S... NaN 2022-12-18 19:32:31 NaN DARK Effect Monster NaN Insect 2300 NaN NaN NaN 0 5 fissioning mother spider
7273 Nanana 98931003 Spell Card Normal Spell Card NaN (Effect,) NaN Unlimited Nanana https://yugipedia.com/wiki/Nanana NaN 2021-04-02 01:33:12 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN nanana
8021 Perfect Great Insect 87804747 Monster Card NaN NaN (Condition, Continuous Effect, Quick Effect, S... NaN Unlimited Perfect Great Insect https://yugipedia.com/wiki/Perfect_Great_Insect NaN 2023-01-11 17:13:54 NaN EARTH Fusion Monster NaN Insect 2600 NaN NaN NaN 3000 9 perfect great insect
Set Card number Name Rarity Print Quantity Region Page URL Modification date Release Series Set type Cover card index
12468 Legacy of Darkness LOD-086 After Genocide (Rare,) NaN NaN NaN https://yugipedia.com/wiki/Set_Card_Lists:Lega... 2020-12-27 02:18:22 2003-06-06 Core Booster Booster pack (Last Turn,) after genocide
12569 Legacy of Darkness LOD-EN086 After Genocide (Rare,) NaN NaN EN https://yugipedia.com/wiki/Set_Card_Lists:Lega... 2020-12-27 02:18:14 2003-06-06 Core Booster Booster pack (Last Turn,) after genocide
12670 Legacy of Darkness LOD-086 After Genocide (Rare,) NaN NaN AE https://yugipedia.com/wiki/Set_Card_Lists:Lega... 2020-12-27 02:17:56 2003-09-18 Core Booster Booster pack (Last Turn,) after genocide
12771 Legacy of Darkness LOD-KR086 After Genocide (Rare,) NaN NaN KR https://yugipedia.com/wiki/Set_Card_Lists:Lega... 2020-12-27 02:18:07 2004-10-18 Core Booster Booster pack (Last Turn,) after genocide
18986 Rise of Destiny RDS-IT030 Big Core (Super Rare, Ultimate Rare) NaN NaN IT https://yugipedia.com/wiki/Set_Card_Lists:Rise... 2020-12-26 00:50:18 2004-12-01 Core Booster Booster pack (The Creator,) big core
... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
219702 Z-one Boss Duel Deck BD-JP025 Z-ONE/Monster A (Common,) NaN NaN JP https://yugipedia.com/wiki/Set_Card_Lists:Z-on... 2021-01-31 12:31:28 2014-07-19 NaN Boss Duel Deck NaN z-one/monster a
219703 Z-one Boss Duel Deck BD-JP026 Z-ONE/Monster B (Common,) NaN NaN JP https://yugipedia.com/wiki/Set_Card_Lists:Z-on... 2021-01-31 12:31:28 2014-07-19 NaN Boss Duel Deck NaN z-one/monster b
219704 Z-one Boss Duel Deck BD-JP027 Z-ONE/Monster C (Common,) NaN NaN JP https://yugipedia.com/wiki/Set_Card_Lists:Z-on... 2021-01-31 12:31:28 2014-07-19 NaN Boss Duel Deck NaN z-one/monster c
219705 Z-one Boss Duel Deck BD-JP028 Z-ONE/Monster D (Common,) NaN NaN JP https://yugipedia.com/wiki/Set_Card_Lists:Z-on... 2021-01-31 12:31:28 2014-07-19 NaN Boss Duel Deck NaN z-one/monster d
219706 Z-one Boss Duel Deck BD-JP029 Z-ONE/Monster E (Common,) NaN NaN JP https://yugipedia.com/wiki/Set_Card_Lists:Z-on... 2021-01-31 12:31:28 2014-07-19 NaN Boss Duel Deck NaN z-one/monster e

634 rows × 14 columns

Epilogue¶

Execution completed 21/03/2023 20:57 UTC

HTML export¶

WARNING: Insecure writes have been enabled via environment variable 'JUPYTER_ALLOW_INSECURE_WRITES'! If this is not intended, remove the variable or set its value to 'False'.
[NbConvertApp] Converting notebook Timeline.ipynb to HTML
[NbConvertApp] Writing 12851124 bytes to ../Timeline.html